﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 站内消息实体类：fanli_message 。
	/// </summary>
	[Serializable]
	public class fanli_message
	{
		public fanli_message()
		{}

		#region Model
		private int _id; //id
		private string _title; //标题
		private string _content; //内容
		private DateTime? _sendTime; //发送时间
		private int _hasread; //是否已读
		private int _receiveUserid; //接收者
		private int _sendUserid; //发送者


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 标题
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 内容
		/// </summary>
		public string content
		{
			set{ _content=value;}
			get{return _content;}
		}
        /// <summary>
		/// 发送时间
		/// </summary>
		public DateTime? sendTime
		{
			set{ _sendTime=value;}
			get{return _sendTime;}
		}
        /// <summary>
		/// 是否已读
		/// </summary>
		public int hasread
		{
			set{ _hasread=value;}
			get{return _hasread;}
		}
        /// <summary>
		/// 接收者
		/// </summary>
		public int receiveUserid
		{
			set{ _receiveUserid=value;}
			get{return _receiveUserid;}
		}
        /// <summary>
		/// 发送者
		/// </summary>
		public int sendUserid
		{
			set{ _sendUserid=value;}
			get{return _sendUserid;}
		}
		#endregion Model

		#region txt document
		/*
站内消息,message
id,标题,内容,发送时间,是否已读,接收者,发送者
id,title,content,sendTime,hasread,receiveUserid,sendUserid
i,c200,t,d,i,i,i

--------------------------
-- 创建表[站内消息]开始: 
-- alter table  [fanli_message] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_message') drop table fanli_message
  CREATE TABLE [fanli_message] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [title] [varchar] (200),
	 [content] [text],
	 [sendTime] [datetime],
	 [hasread] int,
	 [receiveUserid] int,
	 [sendUserid] int
  )

 exec sp_addextendedproperty N'MS_Description',N'站内消息 ',N'user',N'dbo',N'table',N'fanli_message', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_message',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'标题',N'user',N'dbo',N'table',N'fanli_message',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'内容',N'user',N'dbo',N'table',N'fanli_message',N'column',N'content'
 exec sp_addextendedproperty N'MS_Description',N'发送时间',N'user',N'dbo',N'table',N'fanli_message',N'column',N'sendTime'
 exec sp_addextendedproperty N'MS_Description',N'是否已读',N'user',N'dbo',N'table',N'fanli_message',N'column',N'hasread'
 exec sp_addextendedproperty N'MS_Description',N'接收者',N'user',N'dbo',N'table',N'fanli_message',N'column',N'receiveUserid'
 exec sp_addextendedproperty N'MS_Description',N'发送者',N'user',N'dbo',N'table',N'fanli_message',N'column',N'sendUserid'

-- 创建表[站内消息]结束。 
--------------------------

		*/
		#endregion document
	}
}

